<html>
<head>
  <link rel="stylesheet" type="text/css" href="mystyle.css"/>
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
  <script type="text/javascript" src="jquery.js"></script>
  <script type="text/javascript" src="menu.js"></script>
  <script type="text/javascript">
    $(document).ready(function() { buildMenus(); });
  </script>
  <script type="text/javascript">var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));</script>
  <script type="text/javascript">try {var pageTracker = _gat._getTracker("UA-7674244-2");pageTracker._trackPageview();} catch(err) {}</script>
</head>
<body>

<div id="content">
  This data was collected and analyzed using <a href="http://build.kiva.org/" rel="nofollow">http://build.kiva.org/</a>, Oracle, PHP, and various Google tools, such as Google Charts, Google Visualization, and Google Maps.
  <br>
  <br>
  Some other good resources for Kiva information are <a href="http://www.kivalytics.org/">kivalytics</a>, <a href="http://www.kiva.org/about/facts/">Kiva's facts and statistics page</a>, <a href="http://www.kivafriends.org/">Kiva friends</a>, and this list of <a href="http://developers.wiki.kiva.org/AppsAndWidgets">Apps and Widgets</a>.
  <br>
  <!--
  <ol><b>To-do List:</b>
    <li>Continue adding one page for each loan field.</li>
    <li>Add lending action and lender data.</li>
    <li>Include external data.  Loans per capita, loan size adjusted for per-capita GDP, etc.</li>
  </ol>
  <br>
  <ol><b>Long-term to-do list (may never happen):</b>
    <li>A more interactive, business intelligence-like interface.</li>
  </ol>
  <br>
  -->
  <ol>The process of downloading, parsing, and querying the data is not fully automated.  Here are the main files used for creating the database and this website:
    <li><a href="code/Readme.txt">Readme.txt</a></li>
    <li><a href="code/create schemas.sql">create schemas.sql</a> - Create the schemas and necessary permissions.</li>
    <li><a href="code/create kiva objects.sql">create kiva objects.sql</a> - Creates tables, helper functions, and some other objects used to process the data.</li>
    <li><a href="http://build.kiva.org/docs/data/snapshots">Data Snapshots</a> - Grab the latest XML snapshot.  <!--As of 02-Aug-2009, there is at least one showstopper in the data that must be fixed, the language tab is missing in loan file 15.xml.--></li>
    <li><a href="code/pkg_dataLoad.sql">pkg_dataLoad.sql</a> - Parses the XML and loads the data into the tables.  There is still some data that must be manually added, such as languages, currencies, and some country and region information.</li>
    <li><a href="code/website views.sql">website views.sql</a> - Creates the views used to build the website.  If you're interested in the data behind any of the visualizations the views are where you should start looking.</li>
    <li><a href="code/pkg_createPages.sql">pkg_createPages.sql</a> - The package that calls the views and creates the individual pages.</li>


  </ol>
  <br>

  You can use the code however you want, but the data and APIs have some restrictions; see <a href="http://build.kiva.org/" rel="nofollow">build.kiva.org</a> for more information.
  <br>
  <br>
  If you just want to do a one-time import of the data, it might be easiest to use this collection of <a href="code/csvExport.zip">CSV</a> files (161 MB), 
  or this <a href="code/kivaExport.zip">Oracle export</a> (235MB).

  <br>
  <br>
  <br>
  <br>
  <br>
  Special thanks to Lisa for all her help.  :)
  <br>
  <br>

  
</div><!--End content-->
<div id="menu"></div>

</body>
</html>
